UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8UOcfCyVWCfTmd3cbTIBtLiBC+egPfGYXQAw/qQgVo0='
WHERE
key_id = '4c11ed1c537b55614cc73c8f87dbdb76a5f18774ed130aef8bbf9473a3341881'
AND (
token = '8UOcfCyVWCfTmd3cbTIBtLiBC+egPfGYXQAw/qQgVo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)