UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SH64IrbHOsvqqOaleyKUWNhqeEprK1Uu+8DZRSz80+g='
WHERE
key_id = 'f21c8ff73e6245556d9e02b1a88aeb23d9ebd2f05c019e32b55ac289e7e8ea78'
AND (
token = 'SH64IrbHOsvqqOaleyKUWNhqeEprK1Uu+8DZRSz80+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)