UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e3ML8yvkxLsesA/XOZvXF/kONL58LCDrnrOCDEfF4SM='
WHERE
key_id = '97e689ab7aebe0fe3ddc14fca78778c62c7ce3aabd371642c607185a90405543'
AND (
token = 'e3ML8yvkxLsesA/XOZvXF/kONL58LCDrnrOCDEfF4SM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)