UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgQjhHxVn6k1uJOFx0YHCAbJDNJPqnvxg/vRgD8gAiU='
WHERE
key_id = '26404defbe2782bed1ed9a72a2796f5ffd84d06f50e268ba4c705358789ee145'
AND (
token = 'JgQjhHxVn6k1uJOFx0YHCAbJDNJPqnvxg/vRgD8gAiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)