UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h78tWn73bIqWIoFX8WWlEIMQwEpGRaEFuEBLAus3WmY='
WHERE
key_id = 'd149254aa6e12ef3c3224b3c961684de049f41e7812fcda7ed0de9c8298d8fcf'
AND (
token = 'h78tWn73bIqWIoFX8WWlEIMQwEpGRaEFuEBLAus3WmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)