UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4aj1qOU3ErnpuQJeCo+2Eyzirg9PP064hZC5/KlX+4='
WHERE
key_id = '2e1db0bb5be587be09c07e16afb59fd1bc3fbec88286633b332e06de39ed793f'
AND (
token = 'D4aj1qOU3ErnpuQJeCo+2Eyzirg9PP064hZC5/KlX+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)