UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xURZhrxJQRwwsMILwf89sadx2jPyvxLgvHwglR8pduk='
WHERE
key_id = 'ac23518e7636fd370d3efcd452d9873fdfdf4c303d39795039494a85e9356a16'
AND (
token = 'xURZhrxJQRwwsMILwf89sadx2jPyvxLgvHwglR8pduk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)