UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKsC50EfCYXkYJzCES0KWRx42gZiM5ddU9P+arXuLHI='
WHERE
key_id = '790d0047b7de53363d737516ebaed1a60b8e0726259843a4dcc456a64b3ad154'
AND (
token = 'HKsC50EfCYXkYJzCES0KWRx42gZiM5ddU9P+arXuLHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)