UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P3ndfr2KLpnxVTPNPwTPG48V8vztYGJRJM77C1x4OHA='
WHERE
key_id = '30116743f8c4801e2dbe3d467b873783061e5d2f2b32641e4ca0d37cb1820a9d'
AND (
token = 'P3ndfr2KLpnxVTPNPwTPG48V8vztYGJRJM77C1x4OHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)