UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aTrlrDXqCm+1ogxRx1bscGeavlpa3B5OU0Km95Lpzp0='
WHERE
key_id = 'ae1a442e9647d9da8875df76bd51a8f347ac868e481c302ea4d98ecf08cb1de9'
AND (
token = 'aTrlrDXqCm+1ogxRx1bscGeavlpa3B5OU0Km95Lpzp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)