UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AgFi+D8UTZWP/9mVxAR2EtERSVz8F4AA2OC0BmcW1PI='
WHERE
key_id = 'd8a434cb5782317c571536c7d50544d285b037766b7b19565ea3e7da4a2276a4'
AND (
token = 'AgFi+D8UTZWP/9mVxAR2EtERSVz8F4AA2OC0BmcW1PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)