UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1IqrFvBF+31MCccb+FA7E9vDDjx+KodWMZDfWt9bw4='
WHERE
key_id = '7e6b5c273295402533bc29a6098834f5b951f04c86763e4053745f9928741ea9'
AND (
token = 'z1IqrFvBF+31MCccb+FA7E9vDDjx+KodWMZDfWt9bw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)