UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BugW4cp5V0HXD8oBYLtS5FZxfkgAr14RJQhWTV1wk4='
WHERE
key_id = 'd80edc8b25a0f2704671c2c86d9b049162f612338d1121c999a443bad50edc41'
AND (
token = '5BugW4cp5V0HXD8oBYLtS5FZxfkgAr14RJQhWTV1wk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)