UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uiZwQ8+0nJbUn/+nAWnb+8kGacNE4TKmQT0EUYAtNUo='
WHERE
key_id = '6ec3169882eab36d0a098efccb3c065ea56dcf8e4f6c74e48d0a9c2ccba594eb'
AND (
token = 'uiZwQ8+0nJbUn/+nAWnb+8kGacNE4TKmQT0EUYAtNUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)