UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PpP9JjXK2iwbFn2yg60eTU4AfalPuIQJ7qdKJ1cSnFA='
WHERE
key_id = '27c5bc7fd69838f4445f562d9a1156577f5e52e294254f7d1fa6317786879a16'
AND (
token = 'PpP9JjXK2iwbFn2yg60eTU4AfalPuIQJ7qdKJ1cSnFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)