UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yOc3QLtTuUHH00BoOJkWYh6WYJEXITONCzKn+Va+KOE='
WHERE
key_id = 'c2bce35a906cd66fc68513a320feae8e3498318facb62a83cef9dc576ff30eca'
AND (
token = 'yOc3QLtTuUHH00BoOJkWYh6WYJEXITONCzKn+Va+KOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)