UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6E8UQ51S0Qi4VwwIyPIZam2HoYEiRS2W9TV9OT/OEk='
WHERE
key_id = '6283b487f78d17f2e46eec69f18646cef0f270859067e40446137443dbf82891'
AND (
token = 'D6E8UQ51S0Qi4VwwIyPIZam2HoYEiRS2W9TV9OT/OEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)