UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bfpPFsculg0CeeHhmXi6aLYjycvlSTyZ2TYMdGdooMc='
WHERE
key_id = 'f2ef7bd3aa04c86889ca076b5e253199502e65c5f11d8ea2f8bc960b360e91b9'
AND (
token = 'bfpPFsculg0CeeHhmXi6aLYjycvlSTyZ2TYMdGdooMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)