UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNAt92r6ESjSKf90AT5xYvg3gxGW44jiXWFVuMEznzk='
WHERE
key_id = '4cf5359c7dcf1a52320902ee36a3a2904787dc2fd66e8831f513255ee61070ec'
AND (
token = 'sNAt92r6ESjSKf90AT5xYvg3gxGW44jiXWFVuMEznzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)