UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZb92nIHVAZEnNyJiOi7h52yixUXJa83UVhBKn018xU='
WHERE
key_id = '794fd4f58eb2f0d75710e05347c141aa104c67e9f00ee7edfdc78a3896e40b9d'
AND (
token = 'tZb92nIHVAZEnNyJiOi7h52yixUXJa83UVhBKn018xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)