UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WCqGACETo9Vv160jAlYXJEFZ/E4HcPJC7wP8vM3m4Po='
WHERE
key_id = 'a27eda034021a53f852952591ac67413d61916a39d801ee9ef3494427d04421b'
AND (
token = 'WCqGACETo9Vv160jAlYXJEFZ/E4HcPJC7wP8vM3m4Po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)