UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dk49UG4MvOSrA0+OsJWzTxdRRUJe+K4A54WqBupiwE8='
WHERE
key_id = 'fe174c4a12218586862c89adf6b6fa11dc3539129c449b412dd02403f532bca1'
AND (
token = 'Dk49UG4MvOSrA0+OsJWzTxdRRUJe+K4A54WqBupiwE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)