UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sBa7bw6JZTnA1fgAlDXMNEfIsKxg4e5CLrrUsMtY8ts='
WHERE
key_id = '3b8e067ab7e7932289651e5c18bc18180d10c5a95a7968523cb77814cce1ae00'
AND (
token = 'sBa7bw6JZTnA1fgAlDXMNEfIsKxg4e5CLrrUsMtY8ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)