UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OnZ9bSr7jj+2nOY3f7WsTHtuxcOXoHxf3R/rkmJesxY='
WHERE
key_id = '4b5afd43ecdf3fe7a879a5e4a2f84437828a47018566c224c3df6f39e8aecace'
AND (
token = 'OnZ9bSr7jj+2nOY3f7WsTHtuxcOXoHxf3R/rkmJesxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)