UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sznTnSqirkVH4U2AnrfYWYZ7Qiq10igIC3l6O//0Yr4='
WHERE
key_id = 'd690933051c8fe382387ccb5a65ef6e251f90beebe7a2873c3674d477c3b814c'
AND (
token = 'sznTnSqirkVH4U2AnrfYWYZ7Qiq10igIC3l6O//0Yr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)