UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJMScGrMyAZC6yChXJbf6A7q3fqNhTiPt0PtTU3/OnE='
WHERE
key_id = '1c874408098ce9f75ad503e6e484bc91f716feb4c9c4e3a095957a96734cef97'
AND (
token = 'xJMScGrMyAZC6yChXJbf6A7q3fqNhTiPt0PtTU3/OnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)