UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3h/IykkMkThP+ir+mMzW48Iaisd9eXk8/8CPs6gB+hM='
WHERE
key_id = '529e904a895b6e7bea32460f394cd48065aa90a42b039b38f5221db1492b38cc'
AND (
token = '3h/IykkMkThP+ir+mMzW48Iaisd9eXk8/8CPs6gB+hM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)