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