UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIOgUMaty08YIcWOBl0O6v0CsPs4p7DRn3NZouc5Afg='
WHERE
key_id = '31f014435be54989a3f50fdd6d80ff728d5cfd16439d596d64087fb6012f4821'
AND (
token = 'nIOgUMaty08YIcWOBl0O6v0CsPs4p7DRn3NZouc5Afg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)