UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/XYuULbZkJTEV2+jySK2O6rl52wBH/CIB5hdKCEJI0='
WHERE
key_id = '8fd471c2bb15655b63c4e47806219ca31d7f291b57baaf67fb379600335f6414'
AND (
token = 'n/XYuULbZkJTEV2+jySK2O6rl52wBH/CIB5hdKCEJI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)