UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/oWMTiYFdXk5eE5rM6CLgrtkTkUD5wTjVm4XJioxuw='
WHERE
key_id = '338b81b504d615dd3e74d54ce29a2844d0e1f8e0ccdce9fbbd7968139ce85fc0'
AND (
token = 'q/oWMTiYFdXk5eE5rM6CLgrtkTkUD5wTjVm4XJioxuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)