UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxemuOrO47JNvhHxaVk8tg+6Lk+y4n7b81+YO2BFeCI='
WHERE
key_id = '217a2a999ee51854ec4b57d400ff80bf93e860c72f01c4ae3178977934cc5efe'
AND (
token = 'lxemuOrO47JNvhHxaVk8tg+6Lk+y4n7b81+YO2BFeCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)