UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZkwNwWqL0watt/LXg3urvoQmMwk/OOSxPI76Y/GMWU='
WHERE
key_id = '2f64479e540a23982e643190702e12adcd72b2dc506db47028e4d24dc7f6964f'
AND (
token = 'xZkwNwWqL0watt/LXg3urvoQmMwk/OOSxPI76Y/GMWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)