UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHj5IT5HFwqc9JgL6p6jz1mJZGifltlAzzwSMb3UDSU='
WHERE
key_id = '6cdbab9adba5ff35ba73477c2ef0d7e1816cf130c538705e25a65388cbe5e69d'
AND (
token = 'nHj5IT5HFwqc9JgL6p6jz1mJZGifltlAzzwSMb3UDSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)