UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/5wKItXLcD1OM6VogtGKc2tubcjVe0cCeNCj0zlEF4='
WHERE
key_id = '1efa4ee229fca4b561501ec3810a46137d384aa6a5eecdb7d2a6611fca634a96'
AND (
token = 'v/5wKItXLcD1OM6VogtGKc2tubcjVe0cCeNCj0zlEF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)