UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VwTVxWxfTj8ERwpcgVCilH8VossJ65zNA375bCBSoo='
WHERE
key_id = '29e52d60a43f48a08b645b421c8b726339b38078eb1338b173e8d8df4e63dac0'
AND (
token = '9VwTVxWxfTj8ERwpcgVCilH8VossJ65zNA375bCBSoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)